﻿<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="testConnectionString.aspx.cs" Inherits="bridge.Views.testConnectionString" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
    
    </div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:zzCS321_19ConnectionString %>" SelectCommand="SELECT [SongID], [Title], [PublishedDate], [ArtistID], [AlbumID] FROM [Song]"></asp:SqlDataSource>
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="SongID" DataSourceID="SqlDataSource1">
            <Columns>
                <asp:BoundField DataField="SongID" HeaderText="SongID" ReadOnly="True" SortExpression="SongID" />
                <asp:BoundField DataField="Title" HeaderText="Title" SortExpression="Title" />
                <asp:BoundField DataField="PublishedDate" HeaderText="PublishedDate" SortExpression="PublishedDate" />
                <asp:BoundField DataField="ArtistID" HeaderText="ArtistID" SortExpression="ArtistID" />
                <asp:BoundField DataField="AlbumID" HeaderText="AlbumID" SortExpression="AlbumID" />
            </Columns>
        </asp:GridView>
    </form>
</body>
</html>
